﻿CREATE PROCEDURE [dbo].[Hogar_Proveedor_ObtenerTodos]   
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   obtener todos los vinculos
-- Returns:    Proveedor
/*****************************************************************************************************************************************/ 
	
	SELECT  [ProveedorId],
			[Nombre],
			CASE WHEN [Activo] = 1 THEN 1 ELSE 0 END AS [Activo]
	FROM	[dbo].[Proveedor] WITH (NOLOCK)
	WHERE [Activo] = 1
	ORDER BY [Nombre]
	
END